<?php
$this->breadcrumbs=array(
	'Reports',
);
?>

<h1>Reports</h1>
<p>Please choose a report below.</p>
<input type="button" onclick="income_run()" value="Income Statement" />
<br>
<input type="button" onclick="check_run()" value="Check Request" />

<div>
TO DO:<BR/>
	Link to Check Request and Income Statement Pages<BR/>
	- Check Request:<BR/>
		* Search Criteria:<BR/>
			- Artist<BR/>
			- Month<BR/>
		* SELECT *,last_day(str_to_date(concat(@rpt_year, @rpt_month, '01'),'%Y%m%d')) as last_day_of_month<BR/>
			FROM view_check_request<BR/>
		   WHERE artist_id = @RPT_ARTIST_ID AND<BR/>
		         concat(monthname(trans_date), year(trans_date)) = concat(@rpt_month, @rpt_year);<BR/>
		* Also need to get user name running the report to populate "Prepared By"<BR/>
	- Income Statement:<BR/>
		* Search Criteria:<BR/>
			- Date Range<BR/>
		* SELECT * FROM view_income_statement WHERE trans_date BETWEEN @rpt_date_from AND @rpt_date_thru;<BR/>
</div>